<!-- This comment will put IE 6, 7 and 8 in quirks mode -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>eCommerce: Plik źródłowy D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/ShipmentDAO.cs</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Wygenerowano przez Doxygen 1.6.1 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Szukaj');
--></script>
<div class="navigation" id="top">
  <div class="tabs">
    <ul>
      <li><a href="index.html"><span>Strona&nbsp;główna</span></a></li>
      <li><a href="namespaces.html"><span>Pakiety</span></a></li>
      <li><a href="annotated.html"><span>Klasy</span></a></li>
      <li class="current"><a href="files.html"><span>Pliki</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <img id="MSearchSelect" src="search/search.png"
             onmouseover="return searchBox.OnSearchSelectShow()"
             onmouseout="return searchBox.OnSearchSelectHide()"
             alt=""/>
        <input type="text" id="MSearchField" value="Szukaj" accesskey="S"
             onfocus="searchBox.OnSearchFieldFocus(true)" 
             onblur="searchBox.OnSearchFieldFocus(false)" 
             onkeyup="searchBox.OnSearchFieldChange(event)"/>
        <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
        </div>
      </li>
    </ul>
  </div>
  <div class="tabs">
    <ul>
      <li><a href="files.html"><span>Lista&nbsp;plików</span></a></li>
      <li><a href="globals.html"><span>Składowe&nbsp;plików</span></a></li>
    </ul>
  </div>
<h1>D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/ShipmentDAO.cs</h1><a href="_shipment_d_a_o_8cs.html">Idź do dokumentacji tego pliku.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a><a class="code" href="_shipment_d_a_o_8cs.html#a81a223a02c34d82b47199f08308847f2">00001</a> ﻿using <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>;
<a name="l00002"></a>00002 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Collections.Generic;
<a name="l00003"></a>00003 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Text;
<a name="l00004"></a>00004 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.SqlClient;
<a name="l00005"></a>00005 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data;
<a name="l00006"></a>00006 <span class="keyword">using</span> ShopModel;
<a name="l00007"></a>00007 
<a name="l00008"></a>00008 <span class="keyword">namespace </span>ShopDAO
<a name="l00009"></a>00009 {
<a name="l00010"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html">00010</a>     <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html">ShipmentDAO</a>
<a name="l00011"></a>00011     {
<a name="l00012"></a>00012         <span class="keyword">private</span> <span class="keywordtype">string</span> connectionString;
<a name="l00013"></a>00013 
<a name="l00014"></a>00014         <span class="keyword">private</span> SqlConnection Connection()
<a name="l00015"></a>00015         {
<a name="l00016"></a>00016             <span class="keywordflow">return</span> <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00017"></a>00017         }
<a name="l00018"></a>00018 
<a name="l00019"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a9f449b2182fa95a883e0e10e2e275fb5">00019</a>         <span class="keyword">public</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a9f449b2182fa95a883e0e10e2e275fb5">ShipmentDAO</a>()
<a name="l00020"></a>00020         {
<a name="l00021"></a>00021             connectionString = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Configuration.ConfigurationManager.ConnectionStrings[<span class="stringliteral">&quot;csShop&quot;</span>].ConnectionString;
<a name="l00022"></a>00022         }
<a name="l00023"></a>00023 
<a name="l00030"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a34146657239bb11c302d11fb781d2ebe">00030</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a34146657239bb11c302d11fb781d2ebe" title="Zapisuje możliwość przesyłki w bazie Danych (Save shipment option in the database)...">SaveShipmentPossibility</a>(<span class="keywordtype">int</span> PaymentID, <span class="keywordtype">int</span> ShipmentID)
<a name="l00031"></a>00031         {
<a name="l00032"></a>00032             SqlConnection sqlC = Connection();
<a name="l00033"></a>00033             SqlCommand command = sqlC.CreateCommand();
<a name="l00034"></a>00034 
<a name="l00035"></a>00035             command.CommandText = <span class="stringliteral">&quot;SaveShipmentPossibility&quot;</span>;
<a name="l00036"></a>00036             command.CommandType = CommandType.StoredProcedure;
<a name="l00037"></a>00037 
<a name="l00038"></a>00038             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@PaymentID&quot;</span>, PaymentID));
<a name="l00039"></a>00039             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ShipmentID&quot;</span>, ShipmentID));
<a name="l00040"></a>00040 
<a name="l00041"></a>00041             <span class="keywordflow">try</span>
<a name="l00042"></a>00042             {
<a name="l00043"></a>00043                 sqlC.Open();
<a name="l00044"></a>00044 
<a name="l00045"></a>00045                 command.ExecuteNonQuery();
<a name="l00046"></a>00046 
<a name="l00047"></a>00047                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00048"></a>00048             }
<a name="l00049"></a>00049             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00050"></a>00050             {
<a name="l00051"></a>00051                 ErrorLogger.LogError(ex);
<a name="l00052"></a>00052 
<a name="l00053"></a>00053                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00054"></a>00054             }
<a name="l00055"></a>00055             <span class="keywordflow">finally</span>
<a name="l00056"></a>00056             {
<a name="l00057"></a>00057                 sqlC.Close();
<a name="l00058"></a>00058             }
<a name="l00059"></a>00059         }
<a name="l00060"></a>00060 
<a name="l00067"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a92040cb4d536efe074d39b58f6d2db25">00067</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a92040cb4d536efe074d39b58f6d2db25" title="Usuwa możliwość przesyłki w bazie Danych (Deletes shipment option from the database)...">DeleteShipmentPossibility</a>(<span class="keywordtype">int</span> PaymentID, <span class="keywordtype">int</span> ShipmentID)
<a name="l00068"></a>00068         {
<a name="l00069"></a>00069             SqlConnection sqlC = Connection();
<a name="l00070"></a>00070             SqlCommand command = sqlC.CreateCommand();
<a name="l00071"></a>00071 
<a name="l00072"></a>00072             command.CommandText = <span class="stringliteral">&quot;DeleteShipmentPossibility&quot;</span>;
<a name="l00073"></a>00073             command.CommandType = CommandType.StoredProcedure;
<a name="l00074"></a>00074 
<a name="l00075"></a>00075             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@PaymentID&quot;</span>, PaymentID));
<a name="l00076"></a>00076             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ShipmentID&quot;</span>, ShipmentID));
<a name="l00077"></a>00077 
<a name="l00078"></a>00078             <span class="keywordflow">try</span>
<a name="l00079"></a>00079             {
<a name="l00080"></a>00080                 sqlC.Open();
<a name="l00081"></a>00081 
<a name="l00082"></a>00082                 command.ExecuteNonQuery();
<a name="l00083"></a>00083 
<a name="l00084"></a>00084                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00085"></a>00085             }
<a name="l00086"></a>00086             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00087"></a>00087             {
<a name="l00088"></a>00088                 ErrorLogger.LogError(ex);
<a name="l00089"></a>00089                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00090"></a>00090             }
<a name="l00091"></a>00091             <span class="keywordflow">finally</span>
<a name="l00092"></a>00092             {
<a name="l00093"></a>00093                 sqlC.Close();
<a name="l00094"></a>00094             }
<a name="l00095"></a>00095         }
<a name="l00096"></a>00096 
<a name="l00104"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a3bb89842b9c465f475e07a654237160e">00104</a>         <span class="keyword">public</span> List&lt;ShipmentType&gt; <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a3bb89842b9c465f475e07a654237160e" title="Pobiera możliwości wysyłki zapisane w bazie danych (Downloads shipment options...">GetShipmentPossibilities</a>(<span class="keywordtype">int</span> PaymentID, <span class="keywordtype">bool</span> Active, <span class="keywordtype">int</span>? languageID)
<a name="l00105"></a>00105         {
<a name="l00106"></a>00106             List&lt;ShipmentType&gt; result = <span class="keyword">new</span> List&lt;ShipmentType&gt;();
<a name="l00107"></a>00107 
<a name="l00108"></a>00108             SqlConnection sqlC = Connection();
<a name="l00109"></a>00109             SqlCommand command = sqlC.CreateCommand();
<a name="l00110"></a>00110             SqlDataReader sqlR;
<a name="l00111"></a>00111 
<a name="l00112"></a>00112             command.CommandText = <span class="stringliteral">&quot;GetShipmentPossibilities&quot;</span>;
<a name="l00113"></a>00113             command.CommandType = CommandType.StoredProcedure;
<a name="l00114"></a>00114 
<a name="l00115"></a>00115             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@PaymentID&quot;</span>, PaymentID));
<a name="l00116"></a>00116             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@LanguageID&quot;</span>, languageID));
<a name="l00117"></a>00117 
<a name="l00118"></a>00118             <span class="keywordflow">if</span> (Active)
<a name="l00119"></a>00119                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@Active&quot;</span>, Active));
<a name="l00120"></a>00120 
<a name="l00121"></a>00121             <span class="keywordflow">try</span>
<a name="l00122"></a>00122             {
<a name="l00123"></a>00123                 sqlC.Open();
<a name="l00124"></a>00124 
<a name="l00125"></a>00125                 sqlR = command.ExecuteReader();
<a name="l00126"></a>00126 
<a name="l00127"></a>00127                 <span class="keywordflow">while</span> (sqlR.Read())
<a name="l00128"></a>00128                 {
<a name="l00129"></a>00129                     result.Add(<span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_shipment_type.html" title="Klasa przechowuje informacje na temat przesyłki. (Class stores information about...">ShipmentType</a>((<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;IDshipment&quot;</span>], (<span class="keywordtype">string</span>)sqlR[<span class="stringliteral">&quot;ShipmentName&quot;</span>], GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;CountryShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;EUShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;WorldShipmentPrice&quot;</span>])));
<a name="l00130"></a>00130                 }
<a name="l00131"></a>00131             }
<a name="l00132"></a>00132             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00133"></a>00133             {
<a name="l00134"></a>00134                 ErrorLogger.LogError(ex);
<a name="l00135"></a>00135             }
<a name="l00136"></a>00136             <span class="keywordflow">finally</span>
<a name="l00137"></a>00137             {
<a name="l00138"></a>00138                 sqlC.Close();
<a name="l00139"></a>00139             }
<a name="l00140"></a>00140 
<a name="l00141"></a>00141             <span class="keywordflow">return</span> result;
<a name="l00142"></a>00142         }
<a name="l00143"></a>00143 
<a name="l00154"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#ace14b2fe42c4ab8ec322f71e90052564">00154</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#ace14b2fe42c4ab8ec322f71e90052564" title="Zapisuje w bazie nową możliwośc wysyłki (Saves new shipment option in the database)...">SaveShipmentType</a>(<span class="keywordtype">int</span>? ShipmentID, <span class="keywordtype">string</span> Name, decimal CountryShipmentPrice, decimal EUShipmentPrice, decimal WorldShipmentPrice, <span class="keywordtype">int</span>? languageID)
<a name="l00155"></a>00155         {
<a name="l00156"></a>00156             SqlConnection sqlC = Connection();
<a name="l00157"></a>00157             SqlCommand command = sqlC.CreateCommand();
<a name="l00158"></a>00158 
<a name="l00159"></a>00159             command.CommandText = <span class="stringliteral">&quot;SaveShipmentType&quot;</span>;
<a name="l00160"></a>00160             command.CommandType = CommandType.StoredProcedure;
<a name="l00161"></a>00161 
<a name="l00162"></a>00162             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@Name&quot;</span>, Name));
<a name="l00163"></a>00163 
<a name="l00164"></a>00164             <span class="keywordflow">if</span> (CountryShipmentPrice &lt; 0)
<a name="l00165"></a>00165             {
<a name="l00166"></a>00166                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@CountryShipmentPrice&quot;</span>, DBNull.Value));
<a name="l00167"></a>00167             }
<a name="l00168"></a>00168             <span class="keywordflow">else</span>
<a name="l00169"></a>00169             {
<a name="l00170"></a>00170                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@CountryShipmentPrice&quot;</span>, CountryShipmentPrice));
<a name="l00171"></a>00171             }
<a name="l00172"></a>00172 
<a name="l00173"></a>00173             <span class="keywordflow">if</span> (EUShipmentPrice &lt; 0)
<a name="l00174"></a>00174             {
<a name="l00175"></a>00175                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@EUShipmentPrice&quot;</span>, DBNull.Value));
<a name="l00176"></a>00176             }
<a name="l00177"></a>00177             <span class="keywordflow">else</span>
<a name="l00178"></a>00178             {
<a name="l00179"></a>00179                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@EUShipmentPrice&quot;</span>, EUShipmentPrice));
<a name="l00180"></a>00180             }
<a name="l00181"></a>00181 
<a name="l00182"></a>00182             <span class="keywordflow">if</span> (WorldShipmentPrice &lt; 0)
<a name="l00183"></a>00183             {
<a name="l00184"></a>00184                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@WorldShipmentPrice&quot;</span>, DBNull.Value));
<a name="l00185"></a>00185             }
<a name="l00186"></a>00186             <span class="keywordflow">else</span>
<a name="l00187"></a>00187             {
<a name="l00188"></a>00188                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@WorldShipmentPrice&quot;</span>, WorldShipmentPrice));
<a name="l00189"></a>00189             }
<a name="l00190"></a>00190 
<a name="l00191"></a>00191             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@LanguageID&quot;</span>, languageID));
<a name="l00192"></a>00192 
<a name="l00193"></a>00193             <span class="keywordflow">if</span> (ShipmentID != null)
<a name="l00194"></a>00194                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ShipmentID&quot;</span>, ShipmentID));
<a name="l00195"></a>00195 
<a name="l00196"></a>00196             <span class="keywordflow">try</span>
<a name="l00197"></a>00197             {
<a name="l00198"></a>00198                 sqlC.Open();
<a name="l00199"></a>00199 
<a name="l00200"></a>00200                 command.ExecuteNonQuery();
<a name="l00201"></a>00201                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00202"></a>00202             }
<a name="l00203"></a>00203             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00204"></a>00204             {
<a name="l00205"></a>00205                 ErrorLogger.LogError(ex);
<a name="l00206"></a>00206                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00207"></a>00207             }
<a name="l00208"></a>00208             <span class="keywordflow">finally</span>
<a name="l00209"></a>00209             {
<a name="l00210"></a>00210                 sqlC.Close();
<a name="l00211"></a>00211             }
<a name="l00212"></a>00212         }
<a name="l00213"></a>00213 
<a name="l00219"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a0143448eef11c5d196ad03f4c0b8f436">00219</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a0143448eef11c5d196ad03f4c0b8f436" title="Usuwa możliwość wysyłki z bazy danych (Deletes shipment option from the database)...">DeleteShipmentType</a>(<span class="keywordtype">int</span> ShipmentID)
<a name="l00220"></a>00220         {
<a name="l00221"></a>00221             SqlConnection sqlC = Connection();
<a name="l00222"></a>00222             SqlCommand command = sqlC.CreateCommand();
<a name="l00223"></a>00223 
<a name="l00224"></a>00224             command.CommandText = <span class="stringliteral">&quot;DeleteShipmentType&quot;</span>;
<a name="l00225"></a>00225             command.CommandType = CommandType.StoredProcedure;
<a name="l00226"></a>00226 
<a name="l00227"></a>00227             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ShipmentID&quot;</span>, ShipmentID));
<a name="l00228"></a>00228 
<a name="l00229"></a>00229             <span class="keywordflow">try</span>
<a name="l00230"></a>00230             {
<a name="l00231"></a>00231                 sqlC.Open();
<a name="l00232"></a>00232 
<a name="l00233"></a>00233                 command.ExecuteNonQuery();
<a name="l00234"></a>00234 
<a name="l00235"></a>00235                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00236"></a>00236             }
<a name="l00237"></a>00237             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00238"></a>00238             {
<a name="l00239"></a>00239                 ErrorLogger.LogError(ex);
<a name="l00240"></a>00240                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00241"></a>00241             }
<a name="l00242"></a>00242             <span class="keywordflow">finally</span>
<a name="l00243"></a>00243             {
<a name="l00244"></a>00244                 sqlC.Close();
<a name="l00245"></a>00245             }
<a name="l00246"></a>00246         }
<a name="l00247"></a>00247 
<a name="l00254"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a55063155cf45aa586cc67b47377cf36f">00254</a>         <span class="keyword">public</span> <a class="code" href="class_shop_model_1_1_shipment_type.html" title="Klasa przechowuje informacje na temat przesyłki. (Class stores information about...">ShipmentType</a> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a55063155cf45aa586cc67b47377cf36f" title="Pobiera opcję wysyłki po unukalnym id jednaj z opcji wysyłki (Downloads shipment...">GetShipmentType</a>(<span class="keywordtype">int</span> ShipmentID, <span class="keywordtype">int</span>? languageID)
<a name="l00255"></a>00255         {
<a name="l00256"></a>00256 
<a name="l00257"></a>00257             <a class="code" href="class_shop_model_1_1_shipment_type.html" title="Klasa przechowuje informacje na temat przesyłki. (Class stores information about...">ShipmentType</a> result = null ;
<a name="l00258"></a>00258 
<a name="l00259"></a>00259             SqlConnection sqlC = Connection();
<a name="l00260"></a>00260             SqlCommand command = sqlC.CreateCommand();
<a name="l00261"></a>00261             SqlDataReader sqlR;
<a name="l00262"></a>00262 
<a name="l00263"></a>00263             command.CommandText = <span class="stringliteral">&quot;GetShipmentTypes&quot;</span>;
<a name="l00264"></a>00264             command.CommandType = CommandType.StoredProcedure;
<a name="l00265"></a>00265 
<a name="l00266"></a>00266             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@ShipmentID&quot;</span>, ShipmentID));
<a name="l00267"></a>00267             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@LanguageID&quot;</span>, languageID));
<a name="l00268"></a>00268 
<a name="l00269"></a>00269             <span class="keywordflow">try</span>
<a name="l00270"></a>00270             {
<a name="l00271"></a>00271                 sqlC.Open();
<a name="l00272"></a>00272 
<a name="l00273"></a>00273                 sqlR = command.ExecuteReader();
<a name="l00274"></a>00274 
<a name="l00275"></a>00275                 <span class="keywordflow">if</span> (sqlR.Read())
<a name="l00276"></a>00276                 {
<a name="l00277"></a>00277                     result = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_shipment_type.html" title="Klasa przechowuje informacje na temat przesyłki. (Class stores information about...">ShipmentType</a>((<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;IDshipment&quot;</span>], (<span class="keywordtype">string</span>)sqlR[<span class="stringliteral">&quot;ShipmentName&quot;</span>], GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;CountryShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;EUShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;WorldShipmentPrice&quot;</span>]));
<a name="l00278"></a>00278                 }
<a name="l00279"></a>00279             }
<a name="l00280"></a>00280             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00281"></a>00281             {
<a name="l00282"></a>00282                 ErrorLogger.LogError(ex);
<a name="l00283"></a>00283             }
<a name="l00284"></a>00284             <span class="keywordflow">finally</span>
<a name="l00285"></a>00285             {
<a name="l00286"></a>00286                 sqlC.Close();
<a name="l00287"></a>00287             }
<a name="l00288"></a>00288 
<a name="l00289"></a>00289             <span class="keywordflow">return</span> result;
<a name="l00290"></a>00290         }
<a name="l00291"></a>00291 
<a name="l00292"></a>00292 
<a name="l00298"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a403296bf790e9a485679534a9e82eb2f">00298</a>         <span class="keyword">public</span> List&lt;ShipmentType&gt; <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a403296bf790e9a485679534a9e82eb2f" title="Pobiera wszystkie z opcji wysyłki (Downloads all from shipment option).">GetShipmentTypes</a>(<span class="keywordtype">int</span>? languageID)
<a name="l00299"></a>00299         {
<a name="l00300"></a>00300             List&lt;ShipmentType&gt; result = <span class="keyword">new</span> List&lt;ShipmentType&gt;();
<a name="l00301"></a>00301 
<a name="l00302"></a>00302             SqlConnection sqlC = Connection();
<a name="l00303"></a>00303             SqlCommand command = sqlC.CreateCommand();
<a name="l00304"></a>00304             SqlDataReader sqlR;
<a name="l00305"></a>00305 
<a name="l00306"></a>00306             command.CommandText = <span class="stringliteral">&quot;GetShipmentTypes&quot;</span>;
<a name="l00307"></a>00307             command.CommandType = CommandType.StoredProcedure;
<a name="l00308"></a>00308 
<a name="l00309"></a>00309             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@LanguageID&quot;</span>, languageID));
<a name="l00310"></a>00310 
<a name="l00311"></a>00311             <span class="keywordflow">try</span>
<a name="l00312"></a>00312             {
<a name="l00313"></a>00313                 sqlC.Open();
<a name="l00314"></a>00314 
<a name="l00315"></a>00315                 sqlR = command.ExecuteReader();
<a name="l00316"></a>00316 
<a name="l00317"></a>00317                 <span class="keywordflow">while</span> (sqlR.Read())
<a name="l00318"></a>00318                 {
<a name="l00319"></a>00319                     result.Add(<span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_shipment_type.html" title="Klasa przechowuje informacje na temat przesyłki. (Class stores information about...">ShipmentType</a>((<span class="keywordtype">int</span>)sqlR[<span class="stringliteral">&quot;IDshipment&quot;</span>], (<span class="keywordtype">string</span>)sqlR[<span class="stringliteral">&quot;ShipmentName&quot;</span>], GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;CountryShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;EUShipmentPrice&quot;</span>]), GetShipmentPriceValue(sqlR[<span class="stringliteral">&quot;WorldShipmentPrice&quot;</span>])));
<a name="l00320"></a>00320                 }
<a name="l00321"></a>00321 
<a name="l00322"></a>00322                 sqlR.Close();
<a name="l00323"></a>00323             }
<a name="l00324"></a>00324             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00325"></a>00325             {
<a name="l00326"></a>00326                 ErrorLogger.LogError(ex);
<a name="l00327"></a>00327             }
<a name="l00328"></a>00328             <span class="keywordflow">finally</span>
<a name="l00329"></a>00329             {
<a name="l00330"></a>00330                 sqlC.Close();
<a name="l00331"></a>00331             }
<a name="l00332"></a>00332 
<a name="l00333"></a>00333             <span class="keywordflow">return</span> result;
<a name="l00334"></a>00334         }
<a name="l00335"></a>00335 
<a name="l00343"></a><a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a844614e932611458a55825b0930fcd40">00343</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_shipment_d_a_o.html#a844614e932611458a55825b0930fcd40" title="Sprawdza czy można skorzystać w wybranej opcji wysyłki dla danego kraju (Checks...">CheckShipmentPossiblities</a>(<span class="keywordtype">int</span> paymentID, <span class="keywordtype">int</span> shipmentID, <span class="keywordtype">int</span> countryID)
<a name="l00344"></a>00344         {
<a name="l00345"></a>00345             SqlConnection connection = Connection();
<a name="l00346"></a>00346             SqlCommand command = connection.CreateCommand();
<a name="l00347"></a>00347             command.CommandText = <span class="stringliteral">&quot;CheckShipmentPosibilities&quot;</span>;
<a name="l00348"></a>00348             command.CommandType = CommandType.StoredProcedure;
<a name="l00349"></a>00349             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@shipment_id&quot;</span>, shipmentID));
<a name="l00350"></a>00350             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@country_id&quot;</span>, countryID));
<a name="l00351"></a>00351             command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@payment_id&quot;</span>, paymentID));
<a name="l00352"></a>00352 
<a name="l00353"></a>00353             <span class="keywordflow">try</span>
<a name="l00354"></a>00354             {
<a name="l00355"></a>00355                 connection.Open();
<a name="l00356"></a>00356                 <span class="keywordflow">return</span> (<span class="keywordtype">bool</span>)command.ExecuteScalar();
<a name="l00357"></a>00357             }
<a name="l00358"></a>00358             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00359"></a>00359             {
<a name="l00360"></a>00360                 ErrorLogger.LogError(ex);
<a name="l00361"></a>00361                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00362"></a>00362             }
<a name="l00363"></a>00363             <span class="keywordflow">finally</span>
<a name="l00364"></a>00364             {
<a name="l00365"></a>00365                 connection.Close();
<a name="l00366"></a>00366             }
<a name="l00367"></a>00367         }
<a name="l00368"></a>00368 
<a name="l00369"></a>00369         <span class="keyword">private</span> decimal GetShipmentPriceValue(<span class="keywordtype">object</span> value)
<a name="l00370"></a>00370         {
<a name="l00371"></a>00371             <span class="keywordflow">if</span> (value == DBNull.Value)
<a name="l00372"></a>00372             {
<a name="l00373"></a>00373                 <span class="keywordflow">return</span> -1;
<a name="l00374"></a>00374             }
<a name="l00375"></a>00375             <span class="keywordflow">else</span>
<a name="l00376"></a>00376             {
<a name="l00377"></a>00377                 <span class="keywordflow">return</span> (decimal)value;
<a name="l00378"></a>00378             }
<a name="l00379"></a>00379         }
<a name="l00380"></a>00380 
<a name="l00381"></a>00381     }
<a name="l00382"></a>00382 }
</pre></div></div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&nbsp;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&nbsp;</span>Klasy</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&nbsp;</span>Przestrzenie nazw</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&nbsp;</span>Pliki</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&nbsp;</span>Funkcje</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&nbsp;</span>Zmienne</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&nbsp;</span>Wyliczenia</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&nbsp;</span>Właściwości</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&nbsp;</span>Zdarzenia</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<hr size="1"/><address style="text-align: right;"><small>Wygenerowano Mon Nov 9 06:08:17 2009 dla eCommerce programem&nbsp;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.1 </small></address>
</body>
</html>
